Steps to Install Oracle 21c Database

Note: Install the database following the database vendor's instructions. Retain the database installation user name and password for later steps in the installation process.

An Oracle database must use a Unicode character set at creation. Complete the following installation tasks:

Running SQL*Plus

Open SQL*Plus as a user with DBA privileges by running the following command:

sqlplus / as sysdba

User Creation

Create the Oracle users for the OIPA and IVS schemas by executing the following commands in a SQL*Plus session:

create user <OIRW Central Schema User> identified by <OIRW password>;

grant connect, resource to <OIRW Central Schema Username>;

grant UNLIMITED TABLESPACE to <OIRW Central Schema Username>;

grant CREATE TABLE to <OIRW Central Schema Username>;